package com.scm.persist.model.purchase;

import java.util.ArrayList;
import java.util.List;

public class ScmPurchaseExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ScmPurchaseExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberIsNull() {
            addCriterion("purchase_order_number is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberIsNotNull() {
            addCriterion("purchase_order_number is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberEqualTo(String value) {
            addCriterion("purchase_order_number =", value, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberNotEqualTo(String value) {
            addCriterion("purchase_order_number <>", value, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberGreaterThan(String value) {
            addCriterion("purchase_order_number >", value, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_order_number >=", value, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberLessThan(String value) {
            addCriterion("purchase_order_number <", value, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberLessThanOrEqualTo(String value) {
            addCriterion("purchase_order_number <=", value, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberLike(String value) {
            addCriterion("purchase_order_number like", value, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberNotLike(String value) {
            addCriterion("purchase_order_number not like", value, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberIn(List<String> values) {
            addCriterion("purchase_order_number in", values, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberNotIn(List<String> values) {
            addCriterion("purchase_order_number not in", values, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberBetween(String value1, String value2) {
            addCriterion("purchase_order_number between", value1, value2, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderNumberNotBetween(String value1, String value2) {
            addCriterion("purchase_order_number not between", value1, value2, "purchaseOrderNumber");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateIsNull() {
            addCriterion("purchase_order_state is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateIsNotNull() {
            addCriterion("purchase_order_state is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateEqualTo(String value) {
            addCriterion("purchase_order_state =", value, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateNotEqualTo(String value) {
            addCriterion("purchase_order_state <>", value, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateGreaterThan(String value) {
            addCriterion("purchase_order_state >", value, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_order_state >=", value, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateLessThan(String value) {
            addCriterion("purchase_order_state <", value, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateLessThanOrEqualTo(String value) {
            addCriterion("purchase_order_state <=", value, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateLike(String value) {
            addCriterion("purchase_order_state like", value, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateNotLike(String value) {
            addCriterion("purchase_order_state not like", value, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateIn(List<String> values) {
            addCriterion("purchase_order_state in", values, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateNotIn(List<String> values) {
            addCriterion("purchase_order_state not in", values, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateBetween(String value1, String value2) {
            addCriterion("purchase_order_state between", value1, value2, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderStateNotBetween(String value1, String value2) {
            addCriterion("purchase_order_state not between", value1, value2, "purchaseOrderState");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusIsNull() {
            addCriterion("purchase_order_approval_status is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusIsNotNull() {
            addCriterion("purchase_order_approval_status is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusEqualTo(String value) {
            addCriterion("purchase_order_approval_status =", value, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusNotEqualTo(String value) {
            addCriterion("purchase_order_approval_status <>", value, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusGreaterThan(String value) {
            addCriterion("purchase_order_approval_status >", value, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_order_approval_status >=", value, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusLessThan(String value) {
            addCriterion("purchase_order_approval_status <", value, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusLessThanOrEqualTo(String value) {
            addCriterion("purchase_order_approval_status <=", value, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusLike(String value) {
            addCriterion("purchase_order_approval_status like", value, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusNotLike(String value) {
            addCriterion("purchase_order_approval_status not like", value, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusIn(List<String> values) {
            addCriterion("purchase_order_approval_status in", values, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusNotIn(List<String> values) {
            addCriterion("purchase_order_approval_status not in", values, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusBetween(String value1, String value2) {
            addCriterion("purchase_order_approval_status between", value1, value2, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalStatusNotBetween(String value1, String value2) {
            addCriterion("purchase_order_approval_status not between", value1, value2, "purchaseOrderApprovalStatus");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksIsNull() {
            addCriterion("purchase_order_approval_remarks is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksIsNotNull() {
            addCriterion("purchase_order_approval_remarks is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksEqualTo(String value) {
            addCriterion("purchase_order_approval_remarks =", value, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksNotEqualTo(String value) {
            addCriterion("purchase_order_approval_remarks <>", value, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksGreaterThan(String value) {
            addCriterion("purchase_order_approval_remarks >", value, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_order_approval_remarks >=", value, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksLessThan(String value) {
            addCriterion("purchase_order_approval_remarks <", value, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksLessThanOrEqualTo(String value) {
            addCriterion("purchase_order_approval_remarks <=", value, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksLike(String value) {
            addCriterion("purchase_order_approval_remarks like", value, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksNotLike(String value) {
            addCriterion("purchase_order_approval_remarks not like", value, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksIn(List<String> values) {
            addCriterion("purchase_order_approval_remarks in", values, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksNotIn(List<String> values) {
            addCriterion("purchase_order_approval_remarks not in", values, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksBetween(String value1, String value2) {
            addCriterion("purchase_order_approval_remarks between", value1, value2, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderApprovalRemarksNotBetween(String value1, String value2) {
            addCriterion("purchase_order_approval_remarks not between", value1, value2, "purchaseOrderApprovalRemarks");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeIsNull() {
            addCriterion("purchase_order_type is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeIsNotNull() {
            addCriterion("purchase_order_type is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeEqualTo(String value) {
            addCriterion("purchase_order_type =", value, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeNotEqualTo(String value) {
            addCriterion("purchase_order_type <>", value, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeGreaterThan(String value) {
            addCriterion("purchase_order_type >", value, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_order_type >=", value, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeLessThan(String value) {
            addCriterion("purchase_order_type <", value, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeLessThanOrEqualTo(String value) {
            addCriterion("purchase_order_type <=", value, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeLike(String value) {
            addCriterion("purchase_order_type like", value, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeNotLike(String value) {
            addCriterion("purchase_order_type not like", value, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeIn(List<String> values) {
            addCriterion("purchase_order_type in", values, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeNotIn(List<String> values) {
            addCriterion("purchase_order_type not in", values, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeBetween(String value1, String value2) {
            addCriterion("purchase_order_type between", value1, value2, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchaseOrderTypeNotBetween(String value1, String value2) {
            addCriterion("purchase_order_type not between", value1, value2, "purchaseOrderType");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitIsNull() {
            addCriterion("purchasing_unit is null");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitIsNotNull() {
            addCriterion("purchasing_unit is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitEqualTo(String value) {
            addCriterion("purchasing_unit =", value, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitNotEqualTo(String value) {
            addCriterion("purchasing_unit <>", value, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitGreaterThan(String value) {
            addCriterion("purchasing_unit >", value, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitGreaterThanOrEqualTo(String value) {
            addCriterion("purchasing_unit >=", value, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitLessThan(String value) {
            addCriterion("purchasing_unit <", value, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitLessThanOrEqualTo(String value) {
            addCriterion("purchasing_unit <=", value, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitLike(String value) {
            addCriterion("purchasing_unit like", value, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitNotLike(String value) {
            addCriterion("purchasing_unit not like", value, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitIn(List<String> values) {
            addCriterion("purchasing_unit in", values, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitNotIn(List<String> values) {
            addCriterion("purchasing_unit not in", values, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitBetween(String value1, String value2) {
            addCriterion("purchasing_unit between", value1, value2, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingUnitNotBetween(String value1, String value2) {
            addCriterion("purchasing_unit not between", value1, value2, "purchasingUnit");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleIsNull() {
            addCriterion("purchasing_people is null");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleIsNotNull() {
            addCriterion("purchasing_people is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleEqualTo(String value) {
            addCriterion("purchasing_people =", value, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleNotEqualTo(String value) {
            addCriterion("purchasing_people <>", value, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleGreaterThan(String value) {
            addCriterion("purchasing_people >", value, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleGreaterThanOrEqualTo(String value) {
            addCriterion("purchasing_people >=", value, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleLessThan(String value) {
            addCriterion("purchasing_people <", value, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleLessThanOrEqualTo(String value) {
            addCriterion("purchasing_people <=", value, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleLike(String value) {
            addCriterion("purchasing_people like", value, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleNotLike(String value) {
            addCriterion("purchasing_people not like", value, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleIn(List<String> values) {
            addCriterion("purchasing_people in", values, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleNotIn(List<String> values) {
            addCriterion("purchasing_people not in", values, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleBetween(String value1, String value2) {
            addCriterion("purchasing_people between", value1, value2, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchasingPeopleNotBetween(String value1, String value2) {
            addCriterion("purchasing_people not between", value1, value2, "purchasingPeople");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateIsNull() {
            addCriterion("purchase_date is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateIsNotNull() {
            addCriterion("purchase_date is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateEqualTo(Long value) {
            addCriterion("purchase_date =", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateNotEqualTo(Long value) {
            addCriterion("purchase_date <>", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateGreaterThan(Long value) {
            addCriterion("purchase_date >", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateGreaterThanOrEqualTo(Long value) {
            addCriterion("purchase_date >=", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateLessThan(Long value) {
            addCriterion("purchase_date <", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateLessThanOrEqualTo(Long value) {
            addCriterion("purchase_date <=", value, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateIn(List<Long> values) {
            addCriterion("purchase_date in", values, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateNotIn(List<Long> values) {
            addCriterion("purchase_date not in", values, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateBetween(Long value1, Long value2) {
            addCriterion("purchase_date between", value1, value2, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateNotBetween(Long value1, Long value2) {
            addCriterion("purchase_date not between", value1, value2, "purchaseDate");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrIsNull() {
            addCriterion("purchase_date_str is null");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrIsNotNull() {
            addCriterion("purchase_date_str is not null");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrEqualTo(String value) {
            addCriterion("purchase_date_str =", value, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrNotEqualTo(String value) {
            addCriterion("purchase_date_str <>", value, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrGreaterThan(String value) {
            addCriterion("purchase_date_str >", value, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrGreaterThanOrEqualTo(String value) {
            addCriterion("purchase_date_str >=", value, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrLessThan(String value) {
            addCriterion("purchase_date_str <", value, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrLessThanOrEqualTo(String value) {
            addCriterion("purchase_date_str <=", value, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrLike(String value) {
            addCriterion("purchase_date_str like", value, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrNotLike(String value) {
            addCriterion("purchase_date_str not like", value, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrIn(List<String> values) {
            addCriterion("purchase_date_str in", values, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrNotIn(List<String> values) {
            addCriterion("purchase_date_str not in", values, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrBetween(String value1, String value2) {
            addCriterion("purchase_date_str between", value1, value2, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andPurchaseDateStrNotBetween(String value1, String value2) {
            addCriterion("purchase_date_str not between", value1, value2, "purchaseDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIsNull() {
            addCriterion("delivery_date is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIsNotNull() {
            addCriterion("delivery_date is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateEqualTo(Long value) {
            addCriterion("delivery_date =", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotEqualTo(Long value) {
            addCriterion("delivery_date <>", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateGreaterThan(Long value) {
            addCriterion("delivery_date >", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateGreaterThanOrEqualTo(Long value) {
            addCriterion("delivery_date >=", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateLessThan(Long value) {
            addCriterion("delivery_date <", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateLessThanOrEqualTo(Long value) {
            addCriterion("delivery_date <=", value, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateIn(List<Long> values) {
            addCriterion("delivery_date in", values, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotIn(List<Long> values) {
            addCriterion("delivery_date not in", values, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateBetween(Long value1, Long value2) {
            addCriterion("delivery_date between", value1, value2, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateNotBetween(Long value1, Long value2) {
            addCriterion("delivery_date not between", value1, value2, "deliveryDate");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrIsNull() {
            addCriterion("delivery_date_str is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrIsNotNull() {
            addCriterion("delivery_date_str is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrEqualTo(String value) {
            addCriterion("delivery_date_str =", value, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrNotEqualTo(String value) {
            addCriterion("delivery_date_str <>", value, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrGreaterThan(String value) {
            addCriterion("delivery_date_str >", value, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrGreaterThanOrEqualTo(String value) {
            addCriterion("delivery_date_str >=", value, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrLessThan(String value) {
            addCriterion("delivery_date_str <", value, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrLessThanOrEqualTo(String value) {
            addCriterion("delivery_date_str <=", value, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrLike(String value) {
            addCriterion("delivery_date_str like", value, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrNotLike(String value) {
            addCriterion("delivery_date_str not like", value, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrIn(List<String> values) {
            addCriterion("delivery_date_str in", values, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrNotIn(List<String> values) {
            addCriterion("delivery_date_str not in", values, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrBetween(String value1, String value2) {
            addCriterion("delivery_date_str between", value1, value2, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andDeliveryDateStrNotBetween(String value1, String value2) {
            addCriterion("delivery_date_str not between", value1, value2, "deliveryDateStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeIsNull() {
            addCriterion("confirm_time is null");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeIsNotNull() {
            addCriterion("confirm_time is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeEqualTo(Long value) {
            addCriterion("confirm_time =", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeNotEqualTo(Long value) {
            addCriterion("confirm_time <>", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeGreaterThan(Long value) {
            addCriterion("confirm_time >", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeGreaterThanOrEqualTo(Long value) {
            addCriterion("confirm_time >=", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeLessThan(Long value) {
            addCriterion("confirm_time <", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeLessThanOrEqualTo(Long value) {
            addCriterion("confirm_time <=", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeIn(List<Long> values) {
            addCriterion("confirm_time in", values, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeNotIn(List<Long> values) {
            addCriterion("confirm_time not in", values, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeBetween(Long value1, Long value2) {
            addCriterion("confirm_time between", value1, value2, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeNotBetween(Long value1, Long value2) {
            addCriterion("confirm_time not between", value1, value2, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrIsNull() {
            addCriterion("confirm_time_str is null");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrIsNotNull() {
            addCriterion("confirm_time_str is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrEqualTo(String value) {
            addCriterion("confirm_time_str =", value, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrNotEqualTo(String value) {
            addCriterion("confirm_time_str <>", value, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrGreaterThan(String value) {
            addCriterion("confirm_time_str >", value, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrGreaterThanOrEqualTo(String value) {
            addCriterion("confirm_time_str >=", value, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrLessThan(String value) {
            addCriterion("confirm_time_str <", value, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrLessThanOrEqualTo(String value) {
            addCriterion("confirm_time_str <=", value, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrLike(String value) {
            addCriterion("confirm_time_str like", value, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrNotLike(String value) {
            addCriterion("confirm_time_str not like", value, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrIn(List<String> values) {
            addCriterion("confirm_time_str in", values, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrNotIn(List<String> values) {
            addCriterion("confirm_time_str not in", values, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrBetween(String value1, String value2) {
            addCriterion("confirm_time_str between", value1, value2, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeStrNotBetween(String value1, String value2) {
            addCriterion("confirm_time_str not between", value1, value2, "confirmTimeStr");
            return (Criteria) this;
        }

        public Criteria andAmountIsNull() {
            addCriterion("amount is null");
            return (Criteria) this;
        }

        public Criteria andAmountIsNotNull() {
            addCriterion("amount is not null");
            return (Criteria) this;
        }

        public Criteria andAmountEqualTo(Long value) {
            addCriterion("amount =", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotEqualTo(Long value) {
            addCriterion("amount <>", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThan(Long value) {
            addCriterion("amount >", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountGreaterThanOrEqualTo(Long value) {
            addCriterion("amount >=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThan(Long value) {
            addCriterion("amount <", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountLessThanOrEqualTo(Long value) {
            addCriterion("amount <=", value, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountIn(List<Long> values) {
            addCriterion("amount in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotIn(List<Long> values) {
            addCriterion("amount not in", values, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountBetween(Long value1, Long value2) {
            addCriterion("amount between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andAmountNotBetween(Long value1, Long value2) {
            addCriterion("amount not between", value1, value2, "amount");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Long value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Long value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Long value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Long value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Long value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Long value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Long> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Long> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Long value1, Long value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Long value1, Long value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("create_user is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("create_user is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("create_user =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("create_user <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("create_user >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("create_user >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("create_user <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("create_user <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("create_user like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("create_user not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("create_user in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("create_user not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("create_user between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("create_user not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNull() {
            addCriterion("create_user_id is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIsNotNull() {
            addCriterion("create_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdEqualTo(String value) {
            addCriterion("create_user_id =", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotEqualTo(String value) {
            addCriterion("create_user_id <>", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThan(String value) {
            addCriterion("create_user_id >", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("create_user_id >=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThan(String value) {
            addCriterion("create_user_id <", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLessThanOrEqualTo(String value) {
            addCriterion("create_user_id <=", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdLike(String value) {
            addCriterion("create_user_id like", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotLike(String value) {
            addCriterion("create_user_id not like", value, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdIn(List<String> values) {
            addCriterion("create_user_id in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotIn(List<String> values) {
            addCriterion("create_user_id not in", values, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdBetween(String value1, String value2) {
            addCriterion("create_user_id between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andCreateUserIdNotBetween(String value1, String value2) {
            addCriterion("create_user_id not between", value1, value2, "createUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Long value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Long value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Long value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Long value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Long value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Long value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Long> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Long> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Long value1, Long value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Long value1, Long value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("update_user is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("update_user is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("update_user =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("update_user <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("update_user >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("update_user >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("update_user <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("update_user <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("update_user like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("update_user not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("update_user in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("update_user not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("update_user between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("update_user not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdIsNull() {
            addCriterion("update_user_id is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdIsNotNull() {
            addCriterion("update_user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdEqualTo(String value) {
            addCriterion("update_user_id =", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdNotEqualTo(String value) {
            addCriterion("update_user_id <>", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdGreaterThan(String value) {
            addCriterion("update_user_id >", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("update_user_id >=", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdLessThan(String value) {
            addCriterion("update_user_id <", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdLessThanOrEqualTo(String value) {
            addCriterion("update_user_id <=", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdLike(String value) {
            addCriterion("update_user_id like", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdNotLike(String value) {
            addCriterion("update_user_id not like", value, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdIn(List<String> values) {
            addCriterion("update_user_id in", values, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdNotIn(List<String> values) {
            addCriterion("update_user_id not in", values, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdBetween(String value1, String value2) {
            addCriterion("update_user_id between", value1, value2, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIdNotBetween(String value1, String value2) {
            addCriterion("update_user_id not between", value1, value2, "updateUserId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotEqualTo(Long value) {
            addCriterion("tenant_id <>", value, "tenantId");
            return (Criteria) this;
        }
        public Criteria andTenantIdEqualTo(Long value) {
            addCriterion("tenant_id =", value, "tenantId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
